home *** CD-ROM | disk | FTP | other *** search
- <?php
- /* $Id: config_import.lib.php,v 2.42 2005/03/06 14:54:15 nijel Exp $ */
- // vim: expandtab sw=4 ts=4 sts=4:
-
-
- /**
- * This file provides support for older config files.
- */
-
- /**
- * U S A G E
- *
- * After having added a new directive to the config.inc.php file, you need to
- * put some backwards compatibility code into this file.
- *
- * This usually looks like this:
- *
- * if (!isset($myNewDirective)) {
- * $myNewDirective = 'my default value';
- * }
- *
- * If the new directive is meant as a replacement for an old one, please use the
- * following layout:
- *
- * if (!isset($myNewDirective)) {
- * if (isset($myOldDirective)) {
- * $myNewDirective = $myOldDirective;
- * unset($myOldDirective);
- * } else {
- * $myNewDirective = '';
- * }
- * }
- *
- * In order to make this file readable for other developers, please try to use
- * the same order of directives here as you do in config.inc.php.
- *
- * After having done all this, search libraries/common.lib.php for the
- * following paragraph (x and y are integers):
- *
- * if ($cfg['FileRevision'][0] < x || $cfg['FileRevision'][1] < y) {
- * require_once('./libraries/config_import.lib.php');
- * }
- *
- * Finally, set x and y to the _new_ revision number of config.inc.php and
- * you're done! x would be the major version, y the minor version number of the
- * new revision, e.g. 2.34 becomes: x = 2, y = 34
- */
-
- if (!isset($cfg['PmaAbsoluteUri'])) {
- if (isset($cfgPmaAbsoluteUri)) {
- $cfg['PmaAbsoluteUri'] = $cfgPmaAbsoluteUri;
- unset($cfgPmaAbsoluteUri);
- } else {
- $cfg['PmaAbsoluteUri'] = '';
- }
- }
-
- if (!isset($cfg['PmaAbsoluteUri_DisableWarning'])) {
- $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
- }
-
- if (!isset($cfg['PmaNoRelation_DisableWarning'])) {
- $cfg['PmaNoRelation_DisableWarning'] = FALSE;
- }
-
- // do not set a default value here!
- if (!isset($cfg['blowfish_secret'])) {
- $cfg['blowfish_secret'] = '';
- }
-
- if (!isset($cfg['Servers'])) {
- if (isset($cfgServers)) {
- $cfg['Servers'] = $cfgServers;
- unset($cfgServers);
- } else {
- $server = 0;
- }
- }
-
- if (isset($cfg['Servers'])) {
- for ($i=1; (!empty($cfg['Servers'][$i]['host']) || (isset($cfg['Servers'][$i]['connect_type']) && $cfg['Servers'][$i]['connect_type'] == 'socket')); $i++) {
- if (!isset($cfg['Servers'][$i]['host'])) {
- $cfg['Servers'][$i]['host'] = '';
- }
- if (!isset($cfg['Servers'][$i]['port'])) {
- $cfg['Servers'][$i]['port'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['socket'])) {
- $cfg['Servers'][$i]['socket'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['connect_type'])) {
- $cfg['Servers'][$i]['connect_type'] = 'tcp';
- }
-
- if (!isset($cfg['Servers'][$i]['extension'])) {
- $cfg['Servers'][$i]['extension'] = 'mysql';
- }
-
- if (!isset($cfg['Servers'][$i]['controluser']) && isset($cfg['Servers'][$i]['stduser'])) {
- $cfg['Servers'][$i]['controluser'] = $cfg['Servers'][$i]['stduser'];
- $cfg['Servers'][$i]['controlpass'] = $cfg['Servers'][$i]['stdpass'];
- unset($cfg['Servers'][$i]['stduser'], $cfg['Servers'][$i]['stdpass']);
- } else if (!isset($cfg['Servers'][$i]['controluser'])) {
- $cfg['Servers'][$i]['controluser'] = $cfg['Servers'][$i]['controlpass'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['auth_type'])) {
- $cfg['Servers'][$i]['auth_type'] = (isset($cfg['Servers'][$i]['adv_auth']) && $cfg['Servers'][$i]['adv_auth'])
- ? 'http'
- : 'config';
- unset($cfg['Servers'][$i]['adv_auth']);
- }
-
- // for users who use the "first" blowfish mechanism
- if (isset($cfg['Servers'][$i]['blowfish_secret'])) {
- if (empty($cfg['blowfish_secret'])) {
- $cfg['blowfish_secret'] = $cfg['Servers'][$i]['blowfish_secret'];
- }
- unset($cfg['Servers'][$i]['blowfish_secret']);
- }
-
- if (!isset($cfg['Servers'][$i]['compress'])) {
- $cfg['Servers'][$i]['compress'] = FALSE;
- }
-
- if (!isset($cfg['Servers'][$i]['user'])) {
- $cfg['Servers'][$i]['user'] = 'root';
- }
-
- if (!isset($cfg['Servers'][$i]['password'])) {
- $cfg['Servers'][$i]['password'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['only_db'])) {
- $cfg['Servers'][$i]['only_db'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['verbose'])) {
- $cfg['Servers'][$i]['verbose'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['pmadb'])) {
- if (isset($cfg['Servers'][$i]['bookmarkdb'])) {
- $cfg['Servers'][$i]['pmadb'] = $cfg['Servers'][$i]['bookmarkdb'];
- unset($cfg['Servers'][$i]['bookmarkdb']);
- } else {
- $cfg['Servers'][$i]['pmadb'] = '';
- }
- }
-
- if (!isset($cfg['Servers'][$i]['bookmarktable'])) {
- $cfg['Servers'][$i]['bookmarktable'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['relation'])) {
- $cfg['Servers'][$i]['relation'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['table_info'])) {
- $cfg['Servers'][$i]['table_info'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['table_coords'])) {
- $cfg['Servers'][$i]['table_coords'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['column_info'])) {
- if (isset($cfg['Servers'][$i]['column_comments'])) {
- $cfg['Servers'][$i]['column_info'] = $cfg['Servers'][$i]['column_comments'];
- unset($cfg['Servers'][$i]['column_comments']);
- } else {
- $cfg['Servers'][$i]['column_info'] = '';
- }
- }
-
- if (!isset($cfg['Servers'][$i]['pdf_pages'])) {
- $cfg['Servers'][$i]['pdf_pages'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['history'])) {
- $cfg['Servers'][$i]['history'] = '';
- }
-
- if (!isset($cfg['Servers'][$i]['verbose_check'])) {
- $cfg['Servers'][$i]['verbose_check'] = TRUE;
- }
-
- if (!isset($cfg['Servers'][$i]['AllowRoot'])) {
- $cfg['Servers'][$i]['AllowRoot'] = TRUE;
- }
-
- if (!isset($cfg['Servers'][$i]['AllowDeny'])) {
- $cfg['Servers'][$i]['AllowDeny'] = array ('order' => '',
- 'rules' => array());
- }
- }
- }
-
- if (!isset($cfg['ServerDefault'])) {
- if (isset($cfgServerDefault)) {
- $cfg['ServerDefault'] = $cfgServerDefault;
- unset($cfgServerDefault);
- } else {
- $cfg['ServerDefault'] = 1;
- }
- }
-
- if (!isset($cfg['OBGzip'])) {
- if (isset($cfgOBGzip)) {
- $cfg['OBGzip'] = $cfgOBGzip;
- unset($cfgOBGzip);
- } else {
- $cfg['OBGzip'] = 'auto';
- }
- }
-
- if (!isset($cfg['PersistentConnections'])) {
- if (isset($cfgPersistentConnections)) {
- $cfg['PersistentConnections'] = $cfgPersistentConnections;
- unset($cfgPersistentConnections);
- } else {
- $cfg['PersistentConnections'] = FALSE;
- }
- }
-
- if (!isset($cfg['ExecTimeLimit'])) {
- if (isset($cfgExecTimeLimit)) {
- $cfg['ExecTimeLimit'] = $cfgExecTimeLimit;
- unset($cfgExecTimeLimit);
- } else {
- $cfg['ExecTimeLimit'] = 300;
- }
- }
-
- if (!isset($cfg['SkipLockedTables'])) {
- if (isset($cfgSkipLockedTables)) {
- $cfg['SkipLockedTables'] = $cfgSkipLockedTables;
- unset($cfgSkipLockedTables);
- } else {
- $cfg['SkipLockedTables'] = FALSE;
- }
- }
-
- if (!isset($cfg['ShowSQL'])) {
- if (isset($cfgShowSQL)) {
- $cfg['ShowSQL'] = $cfgShowSQL;
- unset($cfgShowSQL);
- } else {
- $cfg['ShowSQL'] = TRUE;
- }
- }
-
- if (!isset($cfg['AllowUserDropDatabase'])) {
- if (isset($cfgAllowUserDropDatabase)) {
- $cfg['AllowUserDropDatabase'] = $cfgAllowUserDropDatabase;
- unset($cfgAllowUserDropDatabase);
- } else {
- $cfg['AllowUserDropDatabase'] = FALSE;
- }
- }
-
- if (!isset($cfg['Confirm'])) {
- if (isset($cfgConfirm)) {
- $cfg['Confirm'] = $cfgConfirm;
- unset($cfgConfirm);
- } else {
- $cfg['Confirm'] = TRUE;
- }
- }
-
- if (!isset($cfg['LoginCookieRecall'])) {
- if (isset($cfgLoginCookieRecall)) {
- $cfg['LoginCookieRecall'] = $cfgLoginCookieRecall;
- unset($cfgLoginCookieRecall);
- } else {
- $cfg['LoginCookieRecall'] = TRUE;
- }
- }
-
- if (!isset($cfg['LoginCookieValidity'])) {
- $cfg['LoginCookieValidity'] = 1800;
- }
-
- if (!isset($cfg['UseDbSearch'])) {
- $cfg['UseDbSearch'] = TRUE;
- }
-
- if (!isset($cfg['IgnoreMultiSubmitErrors'])) {
- $cfg['IgnoreMultiSubmitErrors'] = FALSE;
- }
-
- if (!isset($cfg['VerboseMultiSubmit'])) {
- $cfg['VerboseMultiSubmit'] = TRUE;
- }
-
- if (!isset($cfg['AllowArbitraryServer'])) {
- $cfg['AllowArbitraryServer'] = FALSE;
- }
-
- if (!isset($cfg['LeftFrameLight'])) {
- if (isset($cfgLeftFrameLight)) {
- $cfg['LeftFrameLight'] = $cfgLeftFrameLight;
- unset($cfgLeftFrameLight);
- } else {
- $cfg['LeftFrameLight'] = TRUE;
- }
- }
-
- if (!isset($cfg['LeftFrameTableSeparator'])) {
- $cfg['LeftFrameTableSeparator'] = '__';
- }
-
- if (!isset($cfg['LeftFrameTableLevel'])) {
- $cfg['LeftFrameTableLevel'] = '1';
- }
-
- if (!isset($cfg['LightTabs'])) {
- $cfg['LightTabs'] = FALSE;
- }
-
- if (!isset($cfg['PropertiesIconic'])) {
- $cfg['PropertiesIconic'] = TRUE;
- }
-
- if (!isset($cfg['PropertiesNumColumns'])) {
- $cfg['PropertiesNumColumns'] = 1;
- }
-
- if (!isset($cfg['ShowTooltip'])) {
- if (isset($cfgShowTooltip)) {
- $cfg['ShowTooltip'] = $cfgShowTooltip;
- } else {
- $cfg['ShowTooltip'] = TRUE;
- }
- }
-
- if (!isset($cfg['LeftDisplayLogo'])) {
- $cfg['LeftDisplayLogo'] = TRUE;
- }
-
- if (!isset($cfg['LeftDisplayServers'])) {
- $cfg['LeftDisplayServers'] = FALSE;
- }
-
- if (!isset($cfg['DisplayServersList'])) {
- if (isset($cfg['LeftisplayServersList'])) {
- $cfg['DisplayServersList'] = $cfg['LeftDisplayServersList'];
- } else {
- $cfg['DisplayServersList'] = FALSE;
- }
- }
-
- if (!isset($cfg['ShowStats'])) {
- if (isset($cfgShowStats)) {
- $cfg['ShowStats'] = $cfgShowStats;
- unset($cfgShowStats);
- } else {
- $cfg['ShowStats'] = TRUE;
- }
- }
-
- if (!isset($cfg['ShowMysqlInfo'])) {
- if (isset($cfgShowMysqlInfo)) {
- $cfg['ShowMysqlInfo'] = $cfgShowMysqlInfo;
- unset($cfgShowMysqlInfo);
- } else {
- $cfg['ShowMysqlInfo'] = FALSE;
- }
- }
-
- if (!isset($cfg['ShowMysqlVars'])) {
- if (isset($cfgShowMysqlVars)) {
- $cfg['ShowMysqlVars'] = $cfgShowMysqlVars;
- unset($cfgShowMysqlVars);
- } else {
- $cfg['ShowMysqlVars'] = FALSE;
- }
- }
-
- if (!isset($cfg['ShowPhpInfo'])) {
- if (isset($cfgShowPhpInfo)) {
- $cfg['ShowPhpInfo'] = $cfgShowPhpInfo;
- unset($cfgShowPhpInfo);
- } else {
- $cfg['ShowPhpInfo'] = FALSE;
- }
- }
-
- if (!isset($cfg['ShowChgPassword'])) {
- if (isset($cfgShowChgPassword)) {
- $cfg['ShowChgPassword'] = $cfgShowChgPassword;
- unset($cfgShowChgPassword);
- } else {
- $cfg['ShowChgPassword'] = FALSE;
- }
- }
-
- if (!isset($cfg['SuggestDBName'])) {
- $cfg['SuggestDBName'] = TRUE;
- }
-
- if (!isset($cfg['ShowBlob'])) {
- if (isset($cfgShowBlob)) {
- $cfg['ShowBlob'] = $cfgShowBlob;
- unset($cfgShowBlob);
- } else {
- $cfg['ShowBlob'] = FALSE;
- }
- }
-
- if (!isset($cfg['NavigationBarIconic'])) {
- if (isset($cfgNavigationBarIconic)) {
- $cfg['NavigationBarIconic'] = $cfgNavigationBarIconic;
- unset($cfgNavigationBarIconic);
- } else {
- $cfg['NavigationBarIconic'] = TRUE;
- }
- }
-
- if (!isset($cfg['ShowAll'])) {
- if (isset($cfgShowAll)) {
- $cfg['ShowAll'] = $cfgShowAll;
- unset($cfgShowAll);
- } else {
- $cfg['ShowAll'] = FALSE;
- }
- }
-
- if (!isset($cfg['MaxRows'])) {
- if (isset($cfgMaxRows)) {
- $cfg['MaxRows'] = $cfgMaxRows;
- unset($cfgMaxRows);
- } else {
- $cfg['MaxRows'] = 30;
- }
- }
-
- if (!isset($cfg['Order'])) {
- if (isset($cfgOrder)) {
- $cfg['Order'] = $cfgOrder;
- unset($cfgOrder);
- } else {
- $cfg['Order'] = 'ASC';
- }
- }
-
- if (!isset($cfg['ProtectBinary'])) {
- if (isset($cfgProtectBinary)) {
- $cfg['ProtectBinary'] = $cfgProtectBinary;
- unset($cfgProtectBinary);
- } else if (isset($cfg['ProtectBlob'])) {
- $cfg['ProtectBinary'] = ($cfg['ProtectBlob'] ? 'blob' : FALSE);
- unset($cfg['ProtectBlob']);
- } else if (isset($cfgProtectBlob)) {
- $cfg['ProtectBinary'] = ($cfgProtectBlob ? 'blob' : FALSE);
- unset($cfgProtectBlob);
- } else {
- $cfg['ProtectBinary'] = 'blob';
- }
- }
-
- if (!isset($cfg['ShowFunctionFields'])) {
- if (isset($cfgShowFunctionFields)) {
- $cfg['ShowFunctionFields'] = $cfgShowFunctionFields;
- unset($cfgShowFunctionFields);
- } else {
- $cfg['ShowFunctionFields'] = TRUE;
- }
- }
-
- if (!isset($cfg['CharEditing'])) {
- $cfg['CharEditing'] = 'input';
- }
-
- if (!isset($cfg['InsertRows'])) {
- $cfg['InsertRows'] = 2;
- }
-
- if (!isset($cfg['ZipDump'])) {
- if (isset($cfgZipDump)) {
- $cfg['ZipDump'] = $cfgZipDump;
- unset($cfgZipDump);
- } else {
- $cfg['ZipDump'] = TRUE;
- }
- }
-
- if (!isset($cfg['GZipDump'])) {
- if (isset($cfgGZipDump)) {
- $cfg['GZipDump'] = $cfgGZipDump;
- unset($cfgGZipDump);
- } else {
- $cfg['GZipDump'] = TRUE;
- }
- }
-
- if (!isset($cfg['BZipDump'])) {
- if (isset($cfgBZipDump)) {
- $cfg['BZipDump'] = $cfgBZipDump;
- unset($cfgBZipDump);
- } else {
- $cfg['BZipDump'] = TRUE;
- }
- }
- if (!isset($cfg['CompressOnFly'])) {
- $cfg['CompressOnFly'] = TRUE;
- }
-
- if (!isset($cfg['DefaultTabServer'])) {
- $cfg['DefaultTabServer'] = 'main.php';
- }
-
- if (!isset($cfg['DefaultTabDatabase'])
- // rabus: config.inc.php rev. 1.112 had this default value.
- || $cfg['DefaultTabDatabase'] == 'Structure') {
- $cfg['DefaultTabDatabase'] = 'db_details_structure.php';
- }
-
- if (!isset($cfg['DefaultTabTable'])
- // rabus: config.inc.php rev. 1.112 had this default value.
- || $cfg['DefaultTabTable'] == 'Structure') {
- $cfg['DefaultTabTable'] = 'tbl_properties_structure.php';
- }
-
- if (!isset($cfg['MySQLManualBase'])) {
- if (isset($cfgManualBaseShort)) {
- $cfg['MySQLManualBase'] = $cfgManualBaseShort;
- $cfg['MySQLManualType'] = 'old';
- unset($cfgManualBaseShort);
- } else if (isset($cfg['ManualBaseShort'])) {
- $cfg['MySQLManualBase'] = $cfg['ManualBaseShort'];
- $cfg['MySQLManualType'] = 'old';
- unset($cfg['ManualBaseShort']);
- } else {
- $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en';
- $cfg['MySQLManualType'] = 'searchable';
- }
- }
-
- if (!isset($cfg['MySQLManualType'])) {
- $cfg['MySQLManualType'] = 'none';
- }
-
- if (!isset($cfg['DefaultLang'])) {
- if (isset($cfgDefaultLang)) {
- $cfg['DefaultLang'] = $cfgDefaultLang;
- unset($cfgDefaultLang);
- } else {
- $cfg['DefaultLang'] = 'en-iso-8859-1';
- }
- }
-
- if (!isset($cfg['DefaultCharset'])) {
- $cfg['DefaultCharset'] = 'iso-8859-1';
- }
-
- if (!isset($cfg['AllowAnywhereRecoding'])) {
- $cfg['AllowAnywhereRecoding'] = FALSE;
- }
-
- if (!isset($cfg['RecodingEngine'])) {
- $cfg['RecodingEngine'] = 'auto';
- }
-
- if (!isset($cfg['IconvExtraParams'])) {
- $cfg['IconvExtraParams'] = '';
- }
-
- if (!isset($cfg['Lang']) &&isset($cfgLang)) {
- $cfg['Lang'] = $cfgLang;
- unset($cfgLang);
- }
-
- if (!isset($cfg['LeftPointerEnable'])) {
- $cfg['LeftPointerEnable'] = TRUE;
- }
-
- if (!isset($cfg['BrowsePointerEnable'])) {
- $cfg['BrowsePointerEnable'] = TRUE;
- }
-
-
- if (!isset($cfg['BrowseMarkerEnable'])) {
- $cfg['BrowseMarkerEnable'] = TRUE;
- }
-
- if (!isset($cfg['TextareaCols'])) {
- if (isset($cfgTextareaCols)) {
- $cfg['TextareaCols'] = $cfgTextareaCols;
- unset($cfgTextareaCols);
- } else {
- $cfg['TextareaCols'] = 40;
- }
- }
-
- if (!isset($cfg['LongtextDoubleTextarea'])) {
- $cfg['LongtextDoubleTextarea'] = TRUE;
- }
-
- if (!isset($cfg['TextareaRows'])) {
- if (isset($cfgTextareaRows)) {
- $cfg['TextareaRows'] = $cfgTextareaRows;
- unset($cfgTextareaRows);
- } else {
- $cfg['TextareaRows'] = 7;
- }
- }
-
- if (!isset($cfg['TextareaAutoSelect'])) {
- $cfg['TextareaAutoSelect'] = TRUE;
- }
-
- if (!isset($cfg['CharTextareaCols'])) {
- $cfg['CharTextareaCols'] = 40;
- }
-
- if (!isset($cfg['CharTextareaRows'])) {
- $cfg['CharTextareaRows'] = 2;
- }
-
- if (!isset($cfg['LimitChars'])) {
- if (isset($cfgLimitChars)) {
- $cfg['LimitChars'] = $cfgLimitChars;
- unset($cfgLimitChars);
- } else {
- $cfg['LimitChars'] = 50;
- }
- }
-
- if (!isset($cfg['ModifyDeleteAtLeft'])) {
- if (isset($cfgModifyDeleteAtLeft)) {
- $cfg['ModifyDeleteAtLeft'] = $cfgModifyDeleteAtLeft;
- unset($cfgModifyDeleteAtLeft);
- } else {
- $cfg['ModifyDeleteAtLeft'] = TRUE;
- }
- }
-
- if (!isset($cfg['ModifyDeleteAtRight'])) {
- if (isset($cfgModifyDeleteAtRight)) {
- $cfg['ModifyDeleteAtRight'] = $cfgModifyDeleteAtRight;
- unset($cfgModifyDeleteAtRight);
- } else {
- $cfg['ModifyDeleteAtRight'] = FALSE;
- }
- }
-
- if (!isset($cfg['DefaultDisplay'])) {
- if (isset($cfgDefaultDisplay)) {
- $cfg['DefaultDisplay'] = $cfgDefaultDisplay;
- unset($cfgDefaultDisplay);
- } else {
- $cfg['DefaultDisplay'] = 'horizontal';
- }
- }
- if (!isset($cfg['DefaultPropDisplay'])) {
- $cfg['DefaultPropDisplay'] = 'horizontal';
- }
-
- if (!isset($cfg['RepeatCells'])) {
- if (isset($cfgRepeatCells)) {
- $cfg['RepeatCells'] = $cfgRepeatCells;
- unset($cfgRepeatCells);
- } else {
- $cfg['RepeatCells'] = 100;
- }
- }
-
- if (!isset($cfg['HeaderFlipType'])) {
- $cfg['HeaderFlipType'] = 'css';
- }
-
- if (!isset($cfg['ShowBrowseComments'])) {
- $cfg['ShowBrowseComments'] = TRUE;
- }
-
- if (!isset($cfg['ShowPropertyComments'])) {
- $cfg['ShowPropertyComments'] = TRUE;
- }
-
- if (!isset($cfg['QueryFrame'])) {
- $cfg['QueryFrame'] = TRUE;
- }
-
- if (!isset($cfg['QueryFrameJS'])) {
- $cfg['QueryFrameJS'] = TRUE;
- }
-
- if (!isset($cfg['QueryWindowWidth'])) {
- $cfg['QueryWindowWidth'] = 550;
- }
-
- if (!isset($cfg['QueryWindowHeight'])) {
- $cfg['QueryWindowHeight'] = 310;
- }
-
- if (!isset($cfg['QueryHistoryMax'])) {
- $cfg['QueryHistoryMax'] = 25;
- }
-
- if (!isset($cfg['QueryHistoryDB'])) {
- $cfg['QueryHistoryDB'] = FALSE;
- }
-
- if (!isset($cfg['QueryWindowDefTab'])) {
- $cfg['QueryWindowDefTab'] = 'sql';
- }
-
- if (!isset($cfg['BrowseMIME'])) {
- $cfg['BrowseMIME'] = TRUE;
- }
-
- if (!isset($cfg['MaxExactCount'])) {
- $cfg['MaxExactCount'] = 20000;
- }
-
- if (!isset($cfg['WYSIWYG-PDF'])) {
- $cfg['WYSIWYG-PDF'] = TRUE;
- }
-
- if (!isset($cfg['NaturalOrder'])) {
- $cfg['NaturalOrder'] = TRUE;
- }
-
- if (!isset($cfg['ShowHttpHostTitle'])) {
- $cfg['ShowHttpHostTitle'] = FALSE;
- }
-
- if (!isset($cfg['SetHttpHostTitle'])) {
- $cfg['SetHttpHostTitle'] = '';
- }
-
- if (!isset($cfg['ErrorIconic'])) {
- $cfg['ErrorIconic'] = TRUE;
- }
-
- if (!isset($cfg['MainPageIconic'])) {
- $cfg['MainPageIconic'] = TRUE;
- }
-
- if (!isset($cfg['ReplaceHelpImg'])) {
- $cfg['ReplaceHelpImg'] = TRUE;
- }
-
- if (!isset($cfg['ThemePath'])) {
- $cfg['ThemePath'] = './themes';
- $cfg['ThemeDefault'] = 'original';
- $cfg['ThemeManager'] = TRUE;
- } else {
- if (!isset($cfg['ThemeDefault'])){
- $cfg['ThemeDefault'] = 'original';
- }
- if (!isset($cfg['ThemeManager'])){
- $cfg['ThemeManager'] = TRUE;
- }
- }
-
- if (!isset($cfg['DefaultQueryTable'])) {
- $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
- }
-
- if (!isset($cfg['DefaultQueryDatabase'])) {
- $cfg['DefaultQueryDatabase']= '';
- }
-
- if (!isset($cfg['ShowTooltipAliasDB'])) {
- $cfg['ShowTooltipAliasDB'] = FALSE;
- }
-
- if (!isset($cfg['ShowTooltipAliasTB'])) {
- $cfg['ShowTooltipAliasTB'] = FALSE;
- }
-
- if (!isset($cfg['SQLQuery']['Edit'])) {
- $cfg['SQLQuery']['Edit'] = TRUE;
- }
-
- if (!isset($cfg['SQLQuery']['Explain'])) {
- $cfg['SQLQuery']['Explain'] = TRUE;
- }
-
- if (!isset($cfg['SQLQuery']['ShowAsPHP'])) {
- $cfg['SQLQuery']['ShowAsPHP'] = TRUE;
- }
-
- if (!isset($cfg['SQLQuery']['Validate'])) {
- $cfg['SQLQuery']['Validate'] = FALSE;
- }
-
- if (!isset($cfg['SQLQuery']['Refresh'])) {
- $cfg['SQLQuery']['Refresh'] = TRUE;
- }
-
- if (!isset($cfg['UploadDir'])) {
- $cfg['UploadDir'] = '';
- }
-
- if (!isset($cfg['SaveDir'])) {
- $cfg['SaveDir'] = '';
- }
-
- if (!isset($cfg['docSQLDir'])) {
- $cfg['docSQLDir'] = '';
- }
-
- if (!isset($cfg['TempDir'])) {
- $cfg['TempDir'] = '';
- }
-
-
- if (!isset($cfg['SQLValidator']['use'])) {
- $cfg['SQLValidator']['use'] = FALSE;
- }
-
- if (!isset($cfg['SQLValidator']['username'])) {
- $cfg['SQLValidator']['username'] = '';
- }
-
- if (!isset($cfg['SQLValidator']['password'])) {
- $cfg['SQLValidator']['password'] = '';
- }
-
- if (!isset($cfg['DBG']['enable'])) {
- $cfg['DBG']['enable'] = FALSE;
- }
-
- if (!isset($cfg['DBG']['profile']['enable'])) {
- $cfg['DBG']['profile']['enable'] = FALSE;
- }
-
- if (!isset($cfg['DBG']['profile']['threshold'])) {
- $cfg['DBG']['profile']['threshold'] = 0.5;
- }
-
- if (!isset($cfg['SQP']['fmtType'])) {
- $cfg['SQP']['fmtType'] = 'html';
- }
-
- if (!isset($cfg['SQP']['fmtInd'])) {
- $cfg['SQP']['fmtInd'] = '1';
- }
-
- if (!isset($cfg['SQP']['fmtIndUnit'])) {
- $cfg['SQP']['fmtIndUnit'] = 'em';
- }
-
- if (!isset($cfg['AvailableCharsets'])) {
- $cfg['AvailableCharsets'] = array(
- 'iso-8859-1',
- 'iso-8859-2',
- 'iso-8859-3',
- 'iso-8859-4',
- 'iso-8859-5',
- 'iso-8859-6',
- 'iso-8859-7',
- 'iso-8859-8',
- 'iso-8859-9',
- 'iso-8859-10',
- 'iso-8859-11',
- 'iso-8859-12',
- 'iso-8859-13',
- 'iso-8859-14',
- 'iso-8859-15',
- 'windows-1250',
- 'windows-1251',
- 'windows-1252',
- 'windows-1256',
- 'windows-1257',
- 'koi8-r',
- 'big5',
- 'gb2312',
- 'gbk',
- 'utf-8',
- 'utf-7',
- 'x-user-defined',
- 'euc-jp',
- 'ks_c_5601-1987',
- 'tis-620',
- 'SHIFT_JIS'
- );
- }
-
- if (!isset($cfg['ColumnTypes'])) {
- if (isset($cfgColumnTypes)) {
- $cfg['ColumnTypes'] = $cfgColumnTypes;
- unset($cfgColumnTypes);
- } else {
- $cfg['ColumnTypes'] = array(
- 'VARCHAR',
- 'TINYINT',
- 'TEXT',
- 'DATE',
- 'SMALLINT',
- 'MEDIUMINT',
- 'INT',
- 'BIGINT',
- 'FLOAT',
- 'DOUBLE',
- 'DECIMAL',
- 'DATETIME',
- 'TIMESTAMP',
- 'TIME',
- 'YEAR',
- 'CHAR',
- 'TINYBLOB',
- 'TINYTEXT',
- 'BLOB',
- 'MEDIUMBLOB',
- 'MEDIUMTEXT',
- 'LONGBLOB',
- 'LONGTEXT',
- 'ENUM',
- 'SET'
- );
- }
- }
-
- if (!isset($cfg['AttributeTypes'])) {
- if (isset($cfgAttributeTypes)) {
- $cfg['AttributeTypes'] = $cfgAttributeTypes;
- unset($cfgAttributeTypes);
- } else {
- $cfg['AttributeTypes'] = array(
- '',
- 'BINARY',
- 'UNSIGNED',
- 'UNSIGNED ZEROFILL'
- );
- }
- }
-
- if ($cfg['ShowFunctionFields']) {
- if (!isset($cfg['Functions'])) {
- if (isset($cfgFunctions)) {
- $cfg['Functions'] = $cfgFunctions;
- } else {
- $cfg['Functions'] = array(
- 'ASCII',
- 'CHAR',
- 'SOUNDEX',
- 'LCASE',
- 'UCASE',
- 'NOW',
- 'OLD_PASSWORD',
- 'PASSWORD',
- 'MD5',
- 'SHA1',
- 'ENCRYPT',
- 'RAND',
- 'LAST_INSERT_ID',
- 'COUNT',
- 'AVG',
- 'SUM',
- 'CURDATE',
- 'CURTIME',
- 'FROM_DAYS',
- 'FROM_UNIXTIME',
- 'PERIOD_ADD',
- 'PERIOD_DIFF',
- 'TO_DAYS',
- 'UNIX_TIMESTAMP',
- 'USER',
- 'WEEKDAY',
- 'CONCAT'
- );
- }
-
- // Which column types will be mapped to which Group?
- $cfg['RestrictColumnTypes'] = array(
- 'VARCHAR' => 'FUNC_CHAR',
- 'TINYINT' => 'FUNC_NUMBER',
- 'TEXT' => 'FUNC_CHAR',
- 'DATE' => 'FUNC_DATE',
- 'SMALLINT' => 'FUNC_NUMBER',
- 'MEDIUMINT' => 'FUNC_NUMBER',
- 'INT' => 'FUNC_NUMBER',
- 'BIGINT' => 'FUNC_NUMBER',
- 'FLOAT' => 'FUNC_NUMBER',
- 'DOUBLE' => 'FUNC_NUMBER',
- 'DECIMAL' => 'FUNC_NUMBER',
- 'DATETIME' => 'FUNC_DATE',
- 'TIMESTAMP' => 'FUNC_DATE',
- 'TIME' => 'FUNC_DATE',
- 'YEAR' => 'FUNC_DATE',
- 'CHAR' => 'FUNC_CHAR',
- 'TINYBLOB' => 'FUNC_CHAR',
- 'TINYTEXT' => 'FUNC_CHAR',
- 'BLOB' => 'FUNC_CHAR',
- 'MEDIUMBLOB' => 'FUNC_CHAR',
- 'MEDIUMTEXT' => 'FUNC_CHAR',
- 'LONGBLOB' => 'FUNC_CHAR',
- 'LONGTEXT' => 'FUNC_CHAR',
- 'ENUM' => '',
- 'SET' => ''
- );
-
- // Map above defined groups to any function
- $cfg['RestrictFunctions'] = array(
- 'FUNC_CHAR' => array(
- 'ASCII',
- 'CHAR',
- 'SOUNDEX',
- 'LCASE',
- 'UCASE',
- 'OLD_PASSWORD',
- 'PASSWORD',
- 'MD5',
- 'SHA1',
- 'ENCRYPT',
- 'LAST_INSERT_ID',
- 'USER',
- 'CONCAT'
- ),
-
- 'FUNC_DATE' => array(
- 'NOW',
- 'CURDATE',
- 'CURTIME',
- 'FROM_DAYS',
- 'FROM_UNIXTIME',
- 'PERIOD_ADD',
- 'PERIOD_DIFF',
- 'TO_DAYS',
- 'UNIX_TIMESTAMP',
- 'WEEKDAY'
- ),
-
- 'FUNC_NUMBER' => array(
- 'ASCII',
- 'CHAR',
- 'MD5',
- 'SHA1',
- 'ENCRYPT',
- 'RAND',
- 'LAST_INSERT_ID',
- 'UNIX_TIMESTAMP',
- 'COUNT',
- 'AVG',
- 'SUM'
- )
- );
- }
-
- if (!isset($cfg['DefaultFunctions'])) {
- $cfg['DefaultFunctions'] = array(
- 'FUNC_CHAR' => '',
- 'FUNC_DATE' => '',
- 'FUNC_NUMBER' => '',
- 'first_timestamp' => 'NOW'
- );
- }
- }
-
- if (!isset($cfg['NumOperators'])) {
- $cfg['NumOperators'] = array(
- '=',
- '>',
- '>=',
- '<',
- '<=',
- '!=',
- 'LIKE',
- 'NOT LIKE'
- );
- }
-
- if (!isset($cfg['TextOperators'])) {
- $cfg['TextOperators'] = array(
- 'LIKE',
- 'LIKE %...%',
- 'NOT LIKE',
- '=',
- '!=',
- 'REGEXP',
- 'NOT REGEXP'
- );
- }
-
- if (!isset($cfg['EnumOperators'])) {
- $cfg['EnumOperators'] = array(
- '=',
- '!='
- );
- }
-
- if (!isset($cfg['NullOperators'])) {
- $cfg['NullOperators'] = array(
- 'IS NULL',
- 'IS NOT NULL'
- );
- }
-
- if (!isset($cfg['UnaryOperators'])) {
- $cfg['UnaryOperators'] = array(
- 'IS NULL' => 1,
- 'IS NOT NULL' => 1
- );
- }
-
- if (!isset($cfg['GD2Available'])) {
- $cfg['GD2Available'] = 'auto';
- }
- if (!isset($cfg['PDFPageSizes'])) {
- $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
- }
- if (!isset($cfg['PDFDefaultPageSize'])) {
- $cfg['PDFDefaultPageSize'] = 'A4';
- }
- if (!isset($cfg['CtrlArrowsMoving'])) {
- $cfg['CtrlArrowsMoving'] = TRUE;
- }
-
- if (!isset($cfg['Export'])) {
- $cfg['Export'] = array();
- }
-
- if (!isset($cfg['Export']['format'])) {
- $cfg['Export']['format'] = 'sql';
- } // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword
- if (!isset($cfg['Export']['compression'])) {
- $cfg['Export']['compression'] = 'none';
- } // none/zip/gzip/bzip2
-
- if (!isset($cfg['Export']['asfile'])) {
- $cfg['Export']['asfile'] = FALSE;
- }
- if (!isset($cfg['Export']['onserver'])) {
- $cfg['Export']['onserver'] = FALSE;
- }
- if (!isset($cfg['Export']['onserver_overwrite'])) {
- $cfg['Export']['onserver_overwrite'] = FALSE;
- }
- if (!isset($cfg['Export']['remember_file_template'])) {
- $cfg['Export']['remember_file_template'] = TRUE;
- }
- if (!isset($cfg['Export']['csv_null'])) {
- $cfg['Export']['csv_null'] = 'NULL';
- }
- if (!isset($cfg['Export']['csv_columns'])) {
- $cfg['Export']['csv_columns'] = FALSE;
- }
- if (!isset($cfg['Export']['htmlexcel_null'])) {
- $cfg['Export']['htmlexcel_null'] = 'NULL';
- }
- if (!isset($cfg['Export']['htmlexcel_columns'])) {
- $cfg['Export']['htmlexcel_columns'] = FALSE;
- }
- if (!isset($cfg['Export']['htmlword_structure'])) {
- $cfg['Export']['htmlword_structure'] = TRUE;
- }
- if (!isset($cfg['Export']['htmlword_data'])) {
- $cfg['Export']['htmlword_data'] = TRUE;
- }
- if (!isset($cfg['Export']['htmlword_null'])) {
- $cfg['Export']['htmlword_null'] = 'NULL';
- }
- if (!isset($cfg['Export']['htmlword_columns'])) {
- $cfg['Export']['htmlword_columns'] = FALSE;
- }
- if (!isset($cfg['Export']['xls_null'])) {
- $cfg['Export']['xls_null'] = 'NULL';
- }
- if (!isset($cfg['Export']['xls_columns'])) {
- $cfg['Export']['xls_columns'] = FALSE;
- }
- if (!isset($cfg['Export']['excel_null'])) {
- $cfg['Export']['excel_null'] = 'NULL';
- }
- if (!isset($cfg['Export']['excel_columns'])) {
- $cfg['Export']['excel_columns'] = FALSE;
- }
- if (!isset($cfg['Export']['excel_edition'])) {
- $cfg['Export']['excel_edition'] = 'win';
- }
- if (!isset($cfg['Export']['latex_null'])) {
- $cfg['Export']['latex_null'] = '\textit{NULL}';
- }
- if (!isset($cfg['Export']['csv_separator'])) {
- $cfg['Export']['csv_separator'] = ';';
- }
- if (!isset($cfg['Export']['csv_enclosed'])) {
- $cfg['Export']['csv_enclosed'] = '"';
- }
- if (!isset($cfg['Export']['csv_escaped'])) {
- $cfg['Export']['csv_escaped'] = '\\';
- }
- if (!isset($cfg['Export']['csv_terminated'])) {
- $cfg['Export']['csv_terminated'] = 'AUTO';
- }
-
- if (!isset($cfg['Export']['latex_structure'])) {
- $cfg['Export']['latex_structure'] = TRUE;
- }
- if (!isset($cfg['Export']['latex_data'])) {
- $cfg['Export']['latex_data'] = TRUE;
- }
- if (!isset($cfg['Export']['latex_columns'])) {
- $cfg['Export']['latex_columns'] = TRUE;
- }
- if (!isset($cfg['Export']['latex_relation'])) {
- $cfg['Export']['latex_relation'] = TRUE;
- }
- if (!isset($cfg['Export']['latex_comments'])) {
- $cfg['Export']['latex_comments'] = TRUE;
- }
- if (!isset($cfg['Export']['latex_mime'])) {
- $cfg['Export']['latex_mime'] = TRUE;
- }
- if (!isset($cfg['Export']['latex_caption'])) {
- $cfg['Export']['latex_caption'] = TRUE;
- }
- if (!isset($cfg['Export']['latex_data_label'])) {
- $cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';
- }
- if (!isset($cfg['Export']['latex_structure_label'])) {
- $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';
- }
-
- if (!isset($cfg['Export']['sql_drop_database'])) {
- $cfg['Export']['sql_drop_database'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_disable_fk'])) {
- $cfg['Export']['sql_disable_fk'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_use_transaction'])) {
- $cfg['Export']['sql_use_transaction'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_drop_table'])) {
- $cfg['Export']['sql_drop_table'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_if_not_exists'])) {
- $cfg['Export']['sql_if_not_exists'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_auto_increment'])) {
- $cfg['Export']['sql_auto_increment'] = TRUE;
- }
- if (!isset($cfg['Export']['sql_structure'])) {
- $cfg['Export']['sql_structure'] = TRUE;
- }
- if (!isset($cfg['Export']['sql_data'])) {
- $cfg['Export']['sql_data'] = TRUE;
- }
- if (!isset($cfg['Export']['sql_compat'])) {
- $cfg['Export']['sql_compat'] = 'NONE';
- }
- if (!isset($cfg['Export']['sql_backquotes'])) {
- $cfg['Export']['sql_backquotes'] = TRUE;
- }
- if (!isset($cfg['Export']['sql_dates'])) {
- $cfg['Export']['sql_dates'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_relation'])) {
- $cfg['Export']['sql_relation'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_columns'])) {
- $cfg['Export']['sql_columns'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_delayed'])) {
- $cfg['Export']['sql_delayed'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_ignore'])) {
- $cfg['Export']['sql_ignore'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_hex_for_binary'])) {
- $cfg['Export']['sql_hex_for_binary'] = TRUE;
- }
- if (!isset($cfg['Export']['sql_type'])) {
- $cfg['Export']['sql_type'] = 'insert';
- }
- if (!isset($cfg['Export']['sql_extended'])) {
- $cfg['Export']['sql_extended'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_comments'])) {
- $cfg['Export']['sql_comments'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_mime'])) {
- $cfg['Export']['sql_mime'] = FALSE;
- }
- if (!isset($cfg['Export']['sql_header_comment'])) {
- $cfg['Export']['sql_header_comment'] = '';
- }
-
- ?>
-